
* County-level panel of free lunch eligibility

use kydistccd19871998.dta, clear

keep ncesid countyfip member* fle*

drop flem*

drop *86

reshape long member fle, i(ncesid) j(year)

replace year = year + 1900

collapse (sum) member fle, by(countyfip year)

gen cntyflepct = (fle/member)*100

drop member fle

save cntyflepct19871998, replace
